The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / accoting / dayoset / dayome.exe / DAYOMENU.DOC < prev next >

Wrap

Text File | 1992-06-04 | 178.8 KB | 2,263 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██▄███████████▒░ ███████▒░ ███▒░ ███░ █████████████▒░ ║ ║ ████▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ██▒░ ██▒░ ███▒░ ███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░███░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ████▀▀▀▀▀████▒░ █████▒░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║ ║ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║ ║ ████▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ███▒░ ║ ║ ██▀███████████▒░░ ███▒░ ███▒░ ███▒░ █████████████▒░ ║ ║ ░░░░░░░░░░░░░░ ░░░░ ░░░░ ░░░░ ░░░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ▄██░ ██▄ ████████░ ████░ ███░ ███░ ███░ ║ ║ ████░ ████░ ███░ ████▄ ███░ ███░ ███░ ║ ║ ██████░ ██████░ ███░ ██████▄ ███░ ███░ ███░ ║ ║ ███░███ ███░███░ ███░ ███░███▄ ███░ ███░ ███░ ║ ║ ███░ █████░ ███░ ███████░ ███░ ███▄ ███░ ███░ ███░ ║ ║ ███░ ███░ ███░ ███░ ███░ ███▄███░ ███░ ███░ ║ ║ ███░ ███░ ███░ ███░ ██████░ ███░ ███░ ║ ║ ███░ ███░ ███░ ███░ █████░ ███░ ███░ ║ ║ ███░ ███░ ████████░ ███░ ████░ ▀██████████▀ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ DAYO MENU ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░ Copyright (c) 1990-92, TJS LAB, Inc. ░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ║░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO MENU TJS LAB ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 months after the date of registration or upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO MENU TJS LAB Table of Contents Page Subject ──── ─────────────────────────────────────── 1 ............... INTRODUCTION 2 ............... COPYRIGHT/LICENSE 2 ............... DISCLAIMER 2 ............... REQUIREMENTS *** 2 ............... SETUP 3 ............... MAIN MENU 3 ............... MAIN MENU SCREEN 4 ............... PASSWORD/NAME 5 ............... CONFIGURATION 5 ............... COMPANY NAME 5 ............... COMPANY ADDRESS 6 ............... COMPANY TELEPHONE 6 ............... PRINTER DRIVER (SETUP) 7 ............... PRINTER DRIVER OPTIONS 7 ............... CHANGE DEFAULT PRINTER 8 ............... FULL SCREEN EDIT - F2 8 ............... PRINTER DRIVER DATABASE FIELD DEFINITIONS 9 ............... MENU BROWSE 10 ............... CURRENT DIRECTORY DATABASE LOCATION 10 ............... SCREEN MODE: 25, 43 (EGA), or 50 (VGA) lines 10 ............... SCREEN FONTS 11 ............... READ DAYO USER MANUALS/DOCUMENTS 11 ............... DAYO USER MANUALS & DOCUMENTS LISTING 12 ............... OTHER DOCUMENTS 12 ............... EXAMPLE OF THE READ USER MANUAL SCREEN 12 ............... FIND/SEARCH FOR STRING 13 ............... SYSTEM 13 ............... COLOR MONITOR 13 ............... COLOR INTENSITY 14 ............... MISCELLANEOUS ROUTINES 14 ............... MISC Routines Menu 15 ............... APPEND FROM 17 ............... BROWSE DATABASES 19 ............... COPY (.DBF) TO 21 ............... CREATE DATABASE 23 ............... DELETE RECORDS 24 ............... ERASE FILE DAYO MENU TJS LAB Table of Contents Page Subject ──── ─────────────────────────────────────── 24 ............... EXIT TO DOS 25 ............... INDEX A DATABASE 26 ............... LIST FIELDS 29 ............... MODIFY DATABASE 30 ............... PACK DATABASE 31 ............... RECALL RECORDS 31 ............... RETURN TO MENU 31 ............... RUN (DOS COMMAND) 32 ............... SIMPLE EDITOR 33 ............... SORT DATABASE 34 ............... TYPE (PRINT) FILE 35 ............... ZAP DATABASE 37 ............... HELP SCREENS 39 ............... EXPANDED HELP 39 ............... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 40 ............... VIEW DOCUMENTATION ONSCREEN 40 ............... DATABASE STRUCTURE 40 ............... DATA DICTIONARY 42 ............... TJS LAB, CUSTOM CODING DAYO MENU TJS LAB Page: 1 ████▄ ▄█▄ █░ █░ ▄███▄ █░ █░ ███░ █▄ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░ ██▄▄██░ █░ ██▄ █░ █░ █░ █░ █░ ▄█░█▄ ▀█░█▀ █░ █░ █░██░█░ █░ █▀██░█░ █░ █░ █░ █░ ██▀██░ ▀█▀ █░ █░ █░▐▌ █░ ██░ █░██▄█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░▐▌ █░ █░ █░ ███░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░ ████▀ █░ █░ █░ ▀███▀ █░ █░ ███░ █░ ▀█░ ▀███▀ ■ INTRODUCTION DAYO Menu is a simple menu system for use with the DAYO line of business applications as well as any other program on your computer. It is multiuser when used on a PC based LAN/Network. It can, however be run (like all DAYO products), as a 'standalone' application. Some Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sale (Billing and Invoicing) DAYO Time & Billing Invoicing, Receivables, and Inventory for Services and Products DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO BO Back Orders DAYO GL General Ledger DAYO MRP Materials Requirement Planning DAYO PAYROLL Payroll DAYO EOP End Of Period Posting DAYO Passwords Password protect your DAYO system DAYO Smart Reports A variety of reports pertaining to the above modules DAYOX Network/LAN Index Maintenance Utility DAYO MENU TJS LAB Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO Menu software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using DAYO Menu. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP Run the SETUP program supplied on the 'DAYO Menu, Clock & Setup' disk if you have it. Run DAYOMENU in the \DAYO directory if you use DAYO Setup... If you do not have the Setup disk, install the DAYO Menu files into a a directory on your hard disk (ie: \DAYO). DAYO MENU TJS LAB Page: 3 ■ MAIN MENU From the main menu, use the arrow keys to highlight the menu option/DAYO module that you wish to run, then press Enter/Return. After you exit that DAYO module, you will return to this menu. Pressing the first digit will jump down to the next occurrence of that digit (ie: Pressing 'A' would jump to AR, another press of 'A' would jump to AP...). The last options on the menu are the Configuration and MISC Routines. ■ MAIN MENU SCREEN DAYO MENU Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐ Copyright (c) 1989-1992, All Rights Reserved │S M T W T F S │ ████▄ ▄█▄ █░ █░ ▄███▄ █░ █░ ███░ █▄ █░ █░ █░├────────────────────┤ █░ █░ █░█░ █░ █░ █░ █░ ██▄▄██░ █░ ██▄ █░ █░ █░│ 1 2 3 4 5 6│ █░ █░ ▄█░█▄ ▀█░█▀ █░ █░ █░██░█░ █░ █▀██░█░ █░ █░│ 7 8 9 10 11 12 13│ █░ █░ ██▀██░ ▀█▀ █░ █░ █░▐▌ █░ ██░ █░██▄█░ █░ █░│14 15 16 17 18 19 20│ █░ █░ █░ █░ █░ █░ █░ █░▐▌ █░ █░ █░ ███░ █░ █░│21 22 23 24 25 26 27│ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ██░ █░ █░│28 29 30 │ ████▀ █░ █░ █░ ▀███▀ █░ █░ ███░ █░ ▀█░ ▀███▀ │ │ Available Diskspace: 1,151,871,744 bytes └────────────────────┘ ╔═══════════════════════════════════════════════════════════════════════╗ ░║ Program Name Description of Program 15:03:00 ║ ░╟───────────────────────────────────────────────────────────────────────╢ ░║ AP DAYO Accounts Payable ║ ░║ AR DAYO Accounts Receivable ║ ░║ Back Orders DAYO Customer Back Orders (BO) ║ ░║ Backup DAYO Backup & Restore ║ ░║ Barcode DAYO Barcode Printing ║ ░║ Billing DAYO Billing & Invoicing ║ ░║ Clock DAYO Clock (Requires Graphics Card) ║ ░╟───────────────────────────────────────────────────────────────────────╢ ░║ Esc (Exit) Select Option by highlighting it then pressing Enter... ║ ░╚═══════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ DAYO MENU TJS LAB Page: 4 ■ PASSWORD/NAME From the main menu you can enter any of the modules, but some of them require a password. Passwords for the Configuration and MISC Routines options must be maintained via the DAYO Passwords program. For added security, another option exists which is to add a password to the individual record. The additional password is kept in a field by the same name, at the 'right end' of the record... Before entering the Configuration or MISC Routines menu options, the following screen will appear asking you for your name, or ID/Password if you had installed DAYO Passwords in the current directory: ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: TOM JOHNSON ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 5 ■ CONFIGURATION This main menu selection contains the company name settings, the printer driver/setup routine, the color/intensity of the screen, and routines to maintain your menu selections and the file MENU.BAT. DAYO MENU Version 4.0 TJS LAB CONFIG ┌───[February 1992]──┐ ╔════════════════════════╗ │S M T W T F S │ ░║ CONFIGURATION ║ █░ █░ ███░ █▄ █░ █░ █░ ├────────────────────┤ ░╟────────────────────────╢ ██▄▄██░ █░ ██▄ █░ █░ █░ │ 1│ ░║ Company Name ║ █░██░█░ █░ █▀██░█░ █░ █░ │ 2 3 4 5 6 7 8│ ░║ Company Address ║ █░▐▌ █░ ██░ █░██▄█░ █░ █░ │ 9 10 11 12 13 14 15│ ░║ Company Telephone ║ █░▐▌ █░ █░ █░ ███░ █░ █░ │16 17 18 19 20 21 22│ ░║ Printer Driver/Setup ║ █░ █░ █░ █░ ██░ █░ █░ │23 24 25 26 27 28 29│ ░║ Browse Menu Database ║ █░ █░ ███░ █░ ▀█░ ▀███▀ │30 │ ░║ ****************** ║: 1,828,864 bytes └──────21:18:30──────┘ ░║ ****************** ║═════════════════════════════════════════════════╗ ░║ Current Directory ║scription of Program ║ ░║ Screen Mode/Lines ║─────────────────────────────────────────────────╢ ░║ Screen Font ║mmunications/Modem ║ ░║ Read DAYO Manuals ║mmunications/Modem ║ ░║ System ║hton Tate's dBase (tm) ║ ░╟────────────────────────╢ample of a miscellaneous program ║ ░║ Select Option ║scellaneous Database Management Tools ║ ░╚════════════════════════╝YO Menu Configuration Settings ║ ░░░░░░░░░░░░░░░░░░░░░░░░░░░turn to DOS ║ ░╟───────────────────────────────────────────────────────────────────────╢ ░║ Esc (Exit) Select Option by highlighting it then pressing Enter... ║ ░╚═══════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ■ COMPANY NAME ░╔══════════════════════════════[ COMPANY NAME ]═════════════════════════════╗ ░║ Enter Your Company Name: YOUR COMPANY NAME ║ ░╚═══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ■ COMPANY ADDRESS ░╔════════════════════════════[ COMPANY ADDRESS ]════════════════════════════╗ ░║ Address Line 1: Computer/Data Processing Mgr. ║ ░║ Address Line 2: PO Box 5555 ║ ░║ City, State ZIP: ANYCITY, STATE 55555-5555 ║ ░╚═══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ DAYO MENU TJS LAB Page: 6 ■ COMPANY TELEPHONE ░╔═══════════════════════════[ COMPANY TELEPHONE ]═══════════════════════════╗ ░║ Enter Your Company Telephone: 800-555-5555 ║ ░╚═══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change the printer settings. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO MENU TJS LAB Page: 7 ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO MENU TJS LAB Page: 8 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO MENU TJS LAB Page: 9 ■ MENU BROWSE This is a browse of all your menu selections. From here you can add, edit, and make any changes you wish. The only options you can not change or alter are the MISC Routines and Configuration. To edit, press F2 or just type in your change. Press Ctrl N to add a new menu option. Be sure to enter in all the fields correctly. *** After adding a new menu option/record, remember to rebuild the MENU.BAT. You must reenter MENU.BAT (from DOS) to 'activate' the change... To delete a menu option, press Ctrl U. Remember to 'PACK it out' using the PACK option in MISC Routines... DAYO MENU Version 4.0 TJS LAB CONFIG ┌───[February 1992]──┐ ╔═══════════════════════════════════════════════════════════════════════════╗ ░║ █░ █░ ███░ █▄ █░ █░ █░ █▄███░ █▄██▄ ▄██▄ █░ █ ▄██▄ ███░ ║ ░║ ██▄▄██░ █░ ██▄ █░ █░ █░ █░ █░ █░ █░ █░ █░ █▄ █░ ▄█ █░ █░ ║ ░║ █░██░█░ █░ █▀██░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░█▀█░█░ █░ █░ ║ ░║ █░▐▌ █░ ██░ █░██▄█░ █░ █░ █▄▄▄█░ █▄▄▄█░ █░ █░ █░█░█░█░ ▀██▄ ██░ ║ ░║ █░▐▌ █░ █░ █░ ███░ █░ █░ █░ █░ █▀██░ █░ █░ ▀█▀ ▀█▀ █░ █░ ║ ░║ █░ █░ █░ █░ ██░ █░ █░ █░ █░ █░▀██░ █░ █░ █░ █░ █░ █░ ║ ░║ █░ █░ ███░ █░ ▀█░ ▀███▀ █▀███░ █░ █░ ▀██▀ █░ █░ ▀██▀ ███░ ║ ░╟───────────────────────────────────────────────────────────────────────────╢ ░║ Program: Inventory Name: DAYOINV ║ ░║ Description: DAYO Inventory, Purchasing & Receiving ║ ░║ Location: \DAYOINV ║ ░║ Date Last Run: 08/14/90 Time of Last Run: 22:50:55 Run: 1 ║ ░╟───────────────────────────────────────────────────────────────────────────╢ ░║ PROGRAM PROG_NAME ║ ░║──────────────────────────────────────╥────────────────────────────────────║ ░║ Inventory ║ DAYOINV ║ ░║ POS ║ DAYOPOS ║ ░║ AR ║ DAYOAR ║ ░║ AP ║ DAYOAP ║ ░╚═══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) DAYO MENU TJS LAB Page: 10 ■ CURRENT DIRECTORY DATABASE LOCATION ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOMENU\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ ■ SCREEN MODE: 25, 43 (EGA), or 50 (VGA) lines ╔══════════════[ SCREEN MODE: 25, 43 (EGA), or 50 (VGA) lines ]══════════════╗ ║ If you have an EGA or VGA card, you have the option to display more ║ ║ than the usual 25 lines per screen. ║ ║ The default is 25 lines... ║ ║ Select Option -> Normal: 25 lines ║ ║ EGA: 43 lines ║ ║ VGA: 50 lines ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ SCREEN FONTS Screen fonts are only available for EGA and VGA capable computers... Once set though, they remain in effect until you change them, run another program that resets them, or turn off the computer. ╔═══[ SCREEN FONTS ]═══════════════════════════╗ ║ Select Font -> Standard (Normal) ║ ║ Old English ║ ║ Avante Garde ║ ║ Bauhaus ║ ║ Bodoni ║ ║ Esc (Exit) Broadway ║ ║ Script I ║ ║ Script II ║ ║ Calligraphy ║ ║ Garamond ║ ║ Legend ║ ║ Percy ║ ║ Park Avenue ║ ║ Computer ║ ║ Italic I ║ ║ Italic II ║ ║ Digital ║ ║ Romany ║ ╚══════════════════════════════════════════════╝ DAYO MENU TJS LAB Page: 11 ■ READ DAYO USER MANUALS/DOCUMENTS To facilitate the reading of the hundreds of pages of DAYO User Manuals, this routine is provided to consolidate the viewing in one module. Mouse support is automatic if loaded. ╔══════════════════[ READ DAYO USER MANUALS/DOCUMENTS ]══════════════════╗ ░║ Every DAYO module has its own user manual. Reading/Viewing the manuals ║ ░║ can be accomplished by printing them, accessing them through the HELP ║ ░║ routines (Press F1) in each module, or via this option in DAYO MENU ║ ░║ Configuration. ║ ░║ For costing reasons, frequent updates, and because of the sheer number ║ ░║ of pages, TJS LAB 'recommends' viewing the manuals on your screen. ║ ░║ ║ ░║ Select Manual To Read -> Inventory, Purchasing, Receiving ║ ░║ POS, Point of Sale ║ ░║ Time & Billing ║ ░║ AR, Accounts Receivable ║ ░║ AP, Accounts Payable ║ ░║ GL, General Ledger ║ ░║ Look Up DAYO Databases ║ ░║ Payroll ║ ░║ Quotes ║ ░║ Back Orders ║ ░║ MRP, Materials Requirement Planning ║ ░║ Price Books, Lists ║ ░║ Barcodes ║ ░╚════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ Esc (Exit/Abort) ■ DAYO USER MANUALS & DOCUMENTS LISTING Inventory, Purchasing, Receiving Price Books, Lists POS, Point of Sale Barcodes Time & Billing Graphic Reports AR, Accounts Receivable Sales Contacts AP, Accounts Payable Index GL, General Ledger Passwords Look Up DAYO Databases End of Period, Physical Inventory Payroll Smart Reports & Routines Quotes Update & Conversion Back Orders Clock MRP, Materials Requirement Planning This Menu Program (or Press F1) Price Books, Lists Notice of Enhancements & Features Barcodes DAYO MENU TJS LAB Page: 12 ■ OTHER DOCUMENTS If you wish to view any other document/text file, or DAYO Menu could not find the desired document file in the default locations, a prompt similiar to the following will appear requesting the name and location of the file: ╔═══════════════════════════════════════════════════════════╗ ║ *** Other File *** ║ ║ Enter Name & Location: C:\DAYO\DAYO.TXT ║ ╚═══════════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE READ USER MANUAL SCREEN ╒════════════════════════════════════════════════════════════════════════════╕ │ DAYO BUSINESS APPLICATIONS Page 7 │ │ │ │ DAYO PRICE LIST Prices Effective as of 26 August 199│ │ │ │ DAYOIE DAYO Inventory Registration & Program............ 25.00 ____│ │ DAYOINV DAYO Inventory Source Code ...................... 750.00 ____│ │ DAYOPE DAYO POS Registration & Program.................. 25.00 ____│ │ DAYOPOS DAYO POS Source Code ............................ 750.00 ____│ │ DAYOBE DAYO PB Registration & Program.................. 25.00 ____│ │ DAYOPB DAYO PB Source Code ............................ 400.00 ____│ │ DAYOQE DAYO Quotes Registration & Program............... 25.00 ____│ │ DAYOQUO DAYO Quotes Source Code ......................... 500.00 ____│ │ DAYOXE DAYO Index Registration & Program................ 25.00 ____│ │ DAYOX DAYO Index Source Code ........................... 100.00 ____│ │ DAYOIDE DAYO Password Registration & Program............. 25.00 ____│ │ DAYOPAS DAYO Password Source Code ....................... 100.00 ____│ │ DAYOOE DAYO Back Order Registration & Program........... 25.00 ____│ │ DAYOBO DAYO Back Order Source Code ..................... 600.00 ____│ │════════════════════════════════════════════════════════════════════════════│ │DAYO.TXT │\DAYO\DAYO.TXT │ │ │ │ │ │ ╘════════════════════════════════════════════════════════════════════════════╛ Esc (Exit/Abort) ■ FIND/SEARCH FOR STRING To find a string, word or phrase in the document, press Alt S to bring up a prompt for the string value. The prompt will appear at the lower left of the screen. In the following example, the search is for the string 'PAGE: 44'. Note, the search is not case sensitive ('PAGE' = 'page'). │═══════════════════════════════════════════════════════════════════════════│ │Text: PAGE: 44 │ │ │ │ │ │ ╘═══════════════════════════════════════════════════════════════════════════╛ DAYO MENU TJS LAB Page: 13 ■ SYSTEM This routine will display your system status including an option to set the date and time (will not set the date and time permanently on a LAN). ╔═════════════════════════════════[ SYSTEM ]═════════════════════════════════╗ ║ DOS Version: 3.310 ║ ║ DOS Memory: 640 ║ ║ Free DOS Memory: 0 ║ ║ Extended Memory: 0 ║ ║ Expanded Memory: 0 ║ ║ Parallel Ports: LPT1: ║ ║ Serial Ports: COM1: COM2: ║ ║ CPU Type: 80286 ║ ║ Monitor Type: VGA ║ ║ Available Drives: ABCDE ║ ║ Current Drive: C: ║ ║ Volume Name: ║ ║ Disk Size: 31,950,848 ║ ║ Available Space: 2,232,320 6.99% of Disk Open... ║ ║ Disk Clusters: 15,601 ║ ║ Cluster Size: 2,048 ║ ║ Sectors: 4 ║ ║ Sector Size: 512 ║ ║ Date: 09/07/90 ║ ║ Time: 08:16:23 ║ ║ Change Date and/or Time? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ COLOR MONITOR ░╔═════════════════════════════[ COLOR MONITOR ]════════════════════════════╗ ░║ If you have a color monitor and wish to display colors, then select Y, ║ ░║ (YES), else select N (NO) for monochrome and others. ║ ░║ The default is color, high intensity ║ ░║ ║ ░║ Do you have a color monitor? (Y/N) ║ ░╚══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ■ COLOR INTENSITY ░╔════════════════════════════[ COLOR INTENSITY ]═══════════════════════════╗ ░║ Intensity is only applicable with color set to Y. ║ ░║ It will make your colors brighter... ║ ░║ ║ ░║ Set Color Intensity On? (Y/N) ║ ░╚══════════════════════════════════════════════════════════════════════════╝ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ DAYO MENU TJS LAB Page: 14 ■ MISC ROUTINES - The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC Routines Menu: DAYO MENU Version 4.0 TJS LAB ┌───[February 1992]──┐ ╔════════════════════╗ │S M T W T F S │ ░║ MISC ROUTINES ║██▄ █░ █░ ███░ █▄ █░ █░ █░├────────────────────┤ ░╟────────────────────╢ █░ ██▄▄██░ █░ ██▄ █░ █░ █░│ 1 2 3 4│ ░║ BROWSE DATABASES ║ █░ █░██░█░ █░ █▀██░█░ █░ █░│ 5 6 7 8 9 10 11│ ░║ COPY (.DBF) TO ║ █░ █░▐▌ █░ ██░ █░██▄█░ █░ █░│12 13 14 15 16 17 18│ ░║ CREATE DATABASE ║ █░ █░▐▌ █░ █░ █░ ███░ █░ █░│19 20 21 22 23 24 25│ ░║ DELETE RECORDS ║ █░ █░ █░ █░ █░ ██░ █░ █░│26 27 28 29 30 31 │ ░║ ERASE FILE ║██▀ █░ █░ ███░ █░ ▀█░ ▀███▀ │ │ ░║ EXIT TO DOS ║kspace: 4,128,768 bytes └────────────────────┘ ░║ INDEX A DATABASE ║═════════════════════════════════════════════════════╗ ░║ LIST FIELDS ║ Description of Program ║ ░║ PACK DATABASE ║─────────────────────────────────────────────────────╢ ░║ MODIFY DATABASE ║ Communications/Modem ║ ░║ RECALL RECORDS ║ Communications/Modem ║ ░║ RETURN TO MENU ║ Ashton Tate's dBase (tm) ║ ░║ RUN (DOS COMMAND) ║ Example of a miscellaneous program ║ ░║ SIMPLE EDITOR ║ Miscellaneous Database Management Tools ║ ░║ SORT DATABASE ║ DAYO Menu Configuration Settings ║ ░║ TYPE (PRINT) FILE ║ Return to DOS ║ ░║ ZAP DATABASE ║─────────────────────────────────────────────────────╢ ░╟────────────────────╢ect Option by highlighting it then pressing Enter... ║ ░║ Select Option ║═════════════════════════════════════════════════════╝ ░╚════════════════════╝░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░░░░░░░░░░░░░░░░░░░░ DAYO MENU TJS LAB Page: 15 ■ APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ - If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 16 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 17 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO MENU TJS LAB Page: 18 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation - Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO MENU TJS LAB Page: 19 ■ COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO MENU TJS LAB Page: 20 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 21 - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO MENU TJS LAB Page: 22 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO MENU TJS LAB Page: 23 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO MENU TJS LAB Page: 24 ■ ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO MENU TJS LAB Page: 25 ■ INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 26 - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 27 - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 28 - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 29 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO MENU TJS LAB Page: 30 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 31 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO MENU TJS LAB Page: 32 ■ SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO MENU TJS LAB Page: 33 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 34 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 35 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO MENU TJS LAB Page: 36 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 37 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌──────────────────────[ DAYOPB HELP: DBEDIT, 0, ]──────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌───────────────────────[ DAYOPB HELP: ACHOICE, 0, ]────────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO MENU TJS LAB Page: 38 - Editor help: ┌──────────────────────[ DAYOPB HELP: MEMOEDIT, 0, ]────────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ - User Manual/Screen Help: ┌──────────[ DAYO DAYOMENU HELP Program:WAITKEY Variable: ]───────────┐ │ │ │ - Special keys for 'moving around' the User Manual Read Screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the beginning of file │ │ Ctrl End - Go to the end of file │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Alt S - Find/Search for a string │ │ Alt A - Repeat Search │ │ Esc - Exit │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press any key to continue... DAYO MENU TJS LAB Page: 39 ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO MENU Version 4.0 TJS LAB ┌───[February 1992]──┐ ┌──────[ DAYO HELP Called by Program: DAYOMENU Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOMENU. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO MENU TJS LAB Page: 40 DAYO MENU Version 4.0 TJS LAB ┌───[February 1992]──┐ ┌───────[ DAYO HELP Called by Program: DAYOMENU Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOMENU.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOPAY the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE: 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO MENU TJS LAB Page: 41 ■ DATABASE STRUCTURE Database: DAYOMENU.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PROGRAM Character 15 0 1 15 2 PROG_NAME Character 12 0 16 27 3 DESC Character 50 0 28 77 4 LOCATION Character 40 0 78 117 5 LASTDATE Date 8 0 124 131 6 LASTTIME Character 8 0 132 139 7 NUM_RUNS Numeric 10 0 140 149 8 PASSWORD Character 7 0 150 156 ───── ────────── ───────── ───── ─── ───── ─── Total 157 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── PROGRAM C 15 DAYOMENU.DBF Descriptive name/label for the menu selection PROG_NAME C 12 " Name of the program. Must have an extension of .EXE, .COM or .BAT DESC C 50 " Description of the menu option LOCATION C 40 " Drive/Directory where the program resides LASTDATE D 8 " Last date accessed LASTTIME C 8 " Last time accessed NUM_RUNS N 10 0 " Number of runs since DAYOMENU.DBF was created PASSWORD C 7 " Password to allow access to a specific menu option DAYO MENU TJS LAB Page: 42 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 5:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products.